package zhongbo.java.air.airflightpath.mapper;


import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;
import zhongbo.java.air.airflightpath.model.FlightPath;

@Mapper
public interface AirFlightPathMapper extends BaseMapper<FlightPath> {

    //查询是否相关联air_aircraft飞机表中icaoCode
    @Select("select a.icao_code from air_aircraft a  where icao_code=#{icaoCode}")
    String selectCode(String icaoCode);
}
